Mac Format 1997 January

home *** CD-ROM | disk | FTP | other *** search

/ Mac Format 1997 January / macformat46.iso / File Maker Pro 3.0 Tutorial / File Maker Pro 3.0 / Templates / FileMaker Examples / Integrated Solution / Invoices (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-06-20 | 209KB | 1,079 lines

HBAM2016AUG95 Pro 3.0 Lorraine s Performa 6200 Hard Disk Lorraine Smith HBAM3016AUG95@ 27a This Yearb 10/15/95...10/21/95 I'll perform the find 1a Last Week Pro 3.0F! Pro 3.0J t US Letter A4 Letter US Legal International Fanfold Computer Paper Envelope (#10) els^23456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789 12345M1 21/11/95B 24/5/96C Michael St. LorantD Lorraine SmithE .0825L 5.56M 3 lbsN OvernightR 21/11/95S DennisV SmithW 34 West St.X SwindonY WiltshireZ SW5 7XP[ ACME Accessories\ Cash] 162.92_ 1995` 6/20/96 CANCEL FIND REQUEST CARRIER CONTACT ID CREATED BY CREDIT CARD NUMBER CREDIT CARD TYPE DATE MODIFIED DATE SHIPPED DAY OF INVOICE DATE GRAND TOTAL INVOICE DATE INVOICE ID MODIFIED BY MONTH OF INVOICE DATE PAYMENT AMOUNT PAYMENT METHOD PAYMENT TERMS REPORT NAME SEARCH PERIOD SEARCH PERIOD REPORT SHIP ADDRESS SHIP CITY SHIP COMPANY SHIP COUNTY SHIP FIRST NAME SHIP LAST NAME SHIP POSTAL SHIP THIS INVOICE SHIP TITLE SHIPPING COST SHIPPING PRIORITY SHIPPING WEIGHT SUB TOTAL TAX RATE TAX RATE OPTION TOTAL INVOICE TOTAL RECORDS TOTAL TAX TRACKING NUMBER WEEK OF YEAR YEAR OF INVOICE DATE Invoice DateB Date ModifiedB Created byB Modified byB Invoice IDB Contact IDB Payment TermsB A Sub TotalB Tax RateB Tax Rate OptionB Grand TotalB Shipping CostB Shipping WeightB Shipping PriorityB Tracking NumberB Credit Card NumberB Credit Card TypeB XSThe customer has paid by using a Credit Card. You must enter the Credit Card type. = "Credit Card" Credit Card Date ShippedB CarrierB Ship TitleB "Yes") "" ) Ship First NameB "Yes") "" ) Ship Last NameB "Yes") "" ) Ship AddressB "Yes") "" ) A Ship CityB "Yes") "" ) Ship CountyB "Yes") "" ) Ship PostalB "Yes") "" ) Ship CompanyB "Yes") "" ) Payment MethodB XSThe customer has paid by using a Credit Card. You must enter the Credit Card type. = "Credit Card" Credit Card .075^ I'll perform the findj The Report Namek Cancelled Report Menu Invoice Entry Invoice Entry Help Shipping Entry Find Invoice Summary by Day Summary by Week Summary by Month View as List Summary by Year Print Invoice Report MenuB Payment AmountB X:You must enter a Cash Value into the Payment Amount field. = "Cash" Total RecordsB Year of Invoice DateB Month of Invoice DateB Search PeriodB Search Period ReportB Day of Invoice DateB Total InvoiceB 'A Total TaxB Week of YearB Report NameB Cancel Find RequestB Ship this InvoiceB Invoice EntryB Reports Main Entry View as Reports Invoice Report Line Items Reportsw Summarize by Dayx Summarize by Weeky Summarize by Month{4Creating reports is quite easy and requires 3 steps:| 3. Select the report below.} Find Your Own~/There are currently << ABBO>> Invoice(s) found. B1. Find the Invoices that you would like to create a report with. Your Own Report D:Select the correct search request or Find Your Own Records Summarize by Year 2. Name the report. Invoice Entry HelpB Invoice Data Entry Main Entry View as Reports Invoice Print Invoice Invoice Purchased by Street Address City~ Country Postal Code Company Name Invoice Number Product ID Description Quantity Price Extended Price Title First Credit Card Number Credit Card Type p Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww Invoice Date Shipping EntryB Main Entry View as Reports Customer Print Invoice Invoice uest for the customer who is Invoice Data Entry Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww A0Click to open database files and set preferences pe Click to A)Click to enter information for an invoice A<Click to see a list of the invoices that are currently found A8Click to find an invoice record in the Invoices database A,Use this button to print the current invoice A=Click to choose a predefined print-out such as mailing labels Click to create an invoice for a customer in the Contacts file. After clicking this button, enter a find request for the customer who is purchasing a product and click Find. Select the customer you wish to invoice, click Continue, and complete the invoice A.Click to enter shipment destination and method list of actions taken with t Click to return to data entry Find InvoiceB Shipping Details Main Entry View as Reports Contact Invoice Invoice Data Entry Title First Address County Postal Code Company Name Weight Shipping Priority Tracking Number Date Shipped Carrier Shipping Address Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier Carrier Information Ship this invoice wwwwww Summary by DayB Find an Invoice Main Entry View as Reports Invoice Invoice Data Entryr Title Firstx Address County Postal Code Business Title Company Name Cancel Purchased by Street Address State ZIP Code Company Name Invoice Number Title First Credit Card Number Credit Card Type Product ID Description Quantity Price Extended Price Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Shipping Priority Date Shipped Shipping Info Carrier wwwwww Invoice Invoice Date Invoice Date Summary by WeekB Summary Report by Dayk Printed //l Printed by << AFAAABADABAB>>m Page ##n Search Range: << ABCC>>z Invoice Totals| Tax Totals} << ABCK>> Summary by MonthB Summary Report by Weekh Printed //i Printed by << AFAAABADABAB>>j Page ##k Search Range: << ABCC>>w Invoice Totalsx Tax Totalsy << ABCK>> View as ListB Summary Report by Monthh Printed //i Printed by << AFAAABADABAB>>j Page ##k Search Range: << ABCC>>t Invoice Totalsu Tax Totalsw << ABCK>> Summary by YearB YEAR OF INVOICE DATE FPTHA MSPC@ g(Invoice List - Select an invoice to edit Main Entry View as Reports Invoice First Namev Last Namew Company Namex Invoice ID Print InvoiceB Summary Report by Yearh Printed //i Printed by << AFAAABADABAB>>j Page ##l Search Range: << ABCC>>u Invoice Totalsv Tax Totals ABCK>> Purchased byy Street Address} City~ County Postal Code Company Name Invoice Number Product ID Description Quantity Price Extended Price Title First Credit Card Number Credit Card Type p Sub Total Tax Rate Shipping Cost Grand Total Payment Method Payment Amount Invoice Date AFAAABADABAC>> AFAAABADABAD>> AFAAABADABAE>>, << AFAAABADABAF>> << AFAAABADABAG>> Shipping Address Street Address County Postal Code Company Name Title First Cancel Find "Cancelled" Cancelled Enter Shipping Details "Yes" Create Invoice & Find Customer Create Invoice Sort First Name Helvetica Geneva Times JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! Sort Last Name Sort Company Name Go to Main Menu Go to Reports Find Invoice from Report "I'll perform the find" I'll perform the findB Summarize by Week Go to Data Entry Perform Find for Report "I'll Perform the Find" I'll Perform the Find ! = "Last Week" b)-1)-7) & "..." & b+ (7 - b)-7)) ! = "This Week" b)-1)) & "..." & b+ (7 - ! = "Last Month" b))) & "..." & b)) -1) ! = "This Month" b))) & "..." & Summarize by Monthly Summarize by Yearly Summarize by Day Preview or Print "Preview") PreviewGB9 "Print") PrintG Your Own Script b) + 1 b)) -1) ! = "Last Year" "1/1/" & ( )) -1) & "..." & "12/31/" & ( ))-1) ! = "This Year" "1/1/" & )) & "..." & "12/31/" & ! = "I'll Perform the Find" Last Week This Week Last Month This Month Last Year 1/1/ 12/31/ This Year 1/1/ 12/31/ I'll Perform the Find ) = 0 Cancel dN^ _PO OPENDOC There are no records that match your report's find request.H OKrform Fin Cancel,O\ Please select a find request. Create your own script andB attatch it to a button. Print Invoice Find Invoice from Invoices + = "Cancelled" Cancelled ) = 1 Go to Line Item Reports Your Own Script Find Invoice Find Invoice from Report Find Invoice from Invoices Perform Find for Report Cancel Find Enter Shipping Details Create Invoice & Find Customer Create Invoice Sort First Name Sort Last Name Sort Company Name Go to Main Menu Go to Line Item Reports Go to Reports Go to Data Entry Preview or Print Summarize by Day Summarize by Week Summarize by Monthly Summarize by Yearly Print Invoice Find Invoice wwwwww ffffff UUUUUU DDDDDD 333333 *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff 333333 """""" JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! wwwwww ffffff UUUUUU DDDDDD 333333 """""" #11#22122"3! "#""3"129 wwwwww ffffff UUUUUU DDDDDD 333333 """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVd fEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET DDCD4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! AD@D@ AD@D@ C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ UTdUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww wwxwwxw B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 wwwwww DDDDDD 333333 %US31 %US30 @@BA@ B220 DDDDDD DDDDDD DDDDDD B"#B0 B"#B"$ "2#B"#B"#@ 2$""#B"#@ "2#B"#@ 2$B"#@ UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364, M4%"!!"560&)/<9;989;>3$ "03., PQ wwwwww wwwwww 44444 CCCCC 44444 CCCCC $42" QMSPC FPTHAQDaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:contacts.fp3 MSPCA NAMEA contacts.fp3 RPTHA contacts.fp3 SRPTA contacts.fp3 OMSPC FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:2-Enabled Layouts:Line Items MSPCA NAMEA Line Items RPTHA Line Items SRPTA line_itm.fp3 OMSPC FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.fp3 MSPCA NAMEA Main Menu.fp3 RPTHA ::3-More Changes:Main Menu.fp3 SRPTA main_mnu.fp3 OMSPC ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" )MSPC FPTHA)Daffy:Desktop Folder:x40:FAT:contacts.fp3 MSPCA NAMEA contacts.fp3 SRPTA contacts.fp3 TMSPC FPTHATAPS Drive :Projects:Franz Project:Integrated Solution:28-More Changes:Line Items.fp3 MSPCA NAMEA Line Items.fp3 RPTHA Line Items.fp3 SRPTA line_itm.fp3 (LIST LISTA 30 Day 60 Day 90 Day C.O.D. VDEFA( (LIST LISTA/Overnight Second Day Saturday Ground VDEFA( (LIST LISTA6American Express Diners Discover Card Master Card VDEFA( MSPCA NAMEA Main Menu.fp3 RPTHA Main Menu.fp3 SRPTA main_mnu.fp3 NAMEA Main Menu.fp3 RPTHA Main Menu.fp3 SRPTA main_mnu.fp3 Payment Term ValuesB Shipping Priority ValuesC Credit Card ValuesD Carrier ValuesE Payment MethodF Personal Title ValuesG Search Period ValuesH Ship Invoice Values FMRLA FMRLA FMRLA CustomerB Line ItemsC Main Menu (LIST LISTA%Express Mail Fed-Ex Standard Mail VDEFA( (LIST LISTA Cheque Credit Card VDEFA( (LIST LISTA VDEFA( (LIST LISTAYLast Week This Week Last Month This Month Last Year This Year I'll Perform the Find VDEFA( (LIST LISTA VDEFA( Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter YEAR OF INVOICE DATE FPTHAODaffy:Desktop Folder:Franz Project:FM Pro Solution:3-More Changes:Main Menu.fp3